{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Cost Proposal","Scoring Formula"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":37,"n_cols":15,"rows_kept":37,"merged":[[1,1,1,2],[2,1,2,2],[5,1,5,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[17,1,17,2],[19,1,21,2],[22,1,22,2],[29,1,29,2]]}
[]
[null,"State of Georgia"]
[null,"In Conjunction with NASPO ValuePoint"]
[null,"Electronic Request for Proposals (\"eRFP\")"]
[null,"eRFP (Event) Number: 41900-DCH0000136"]
[null,"Event Name: Pharmacy Benefit Services"]
[null,"Attachment Z - Pharmacy Drug Rebate Services Cost Worksheet"]
[]
[null,"Instructions for Supplier"]
[null,"\nSuppliers are bidding on the Design, Development and Implementation (DDI), monthly operational costs, and additional program support the Supplier will charge to administer the Pharmacy Drug Rebate Program as described in the eRFP. Please refer to the instructions below, Attachment A eRFP document \"Section 5, Cost Proposal,\" Attachment C - Common Scope Requirements and Security Standards and Attachment I - Pharmacy Drug Rebate Services Scope of Work for details describing the scope of the system implementation services and Rebate Services to be provided before completing this Cost Worksheet."]
[null,1,"Suppliers shall complete the Cost Proposal worksheet using the cells highlighted in yellow."]
[null,2,"Suppliers shall not modify any cells in the spreadsheet other than those highlighted yellow. The other cells are fixed or will calculate automatically."]
[null,3,"Suppliers shall insert 0 in any yellow highlighted cells that are not applicable or for which the proposed cost is zero ($0)."]
[null,4,"Suppliers shall not modify the formulas in the worksheets."]
[null,5,"Suppliers shall provide in Table C a breakdown of their average annual operation and maintenance costs across the ten-year period provided in Tables B.2 and B.3. "]
[null,6,"For evaluation purposes, the total cost will be determined by the value found in F14 which is comprised of the sum of the total DDI Costs (Table A), Drug Rebate System Costs (Table B.1), and the CMS (Table B.2) and Supplemental Rebate (Table B.3) Administrative Costs over a period of ten (10) years."]
[]
[null,"Instructions for Adjusting Costs One or More Years After the Effective Date of the Master Agreement  "]
[{"$nulls":14}," "]
[null,"For Participating Addenda signed one year or more years after the Effective Date of the Master Agreement, the cost will be adjusted using the Consumer Price Index Urban (CPI-U) to account for economic changes that may impact cost. "]
[]
[]
[null,"CPI-U for United States Adjustment Factor Calculation:",{"$nulls":12}," "]
[null,"A:","CPI-U Index for the month and year of the execution of a Participating Addendum",{"$nulls":11}," "]
[null,"B:","Less the CPI-U Index for the month and year of the Effective Date of the Master Agreement",{"$nulls":11}," "]
[null,"C:","Equals Index Point Change",{"$nulls":11}," "]
[null,"D:","Divided by CPI-U Index B: C/B = D",{"$nulls":11}," "]
[null,"E:","Result multiplied by 100: D*100 = E: Equals CPI-U Inflation Percentage",{"$nulls":11}," "]
[null," ",{"$nulls":12}," "]
[null,"Steps to Adjust Costs for CPI-U",{"$nulls":12}," "]
[null,1,"Follow the link below to access the CPI-U data."]
[null,null,"https://www.bls.gov/cpi/tables/supplemental-files/home.htm"]
[null,2,"Select, download and save the file with the most recently published CPI-U data that is available for the month the Participating Addendum is signed. (Also find and select the CPI-U for when the Master Agreement was originally executed). Use the “All Items” CPI-U “Unadjusted indexes” values instead of the “Seasonally adjusted indexes” values."]
[null,3,"Enter the CPI-U value from the previous step in field C94 \"CPI-U for Participating Addendum Date.\"",{"$nulls":11}," "]
[null,4,"Enter the CPI-U value for the month of the Effective Date of the Master Agreement in C93 \"CPI-U for Master Agreement Date MM/DD/20YY.\" "]
[null,5,"The “CPI-U Inflation Percentage” will be calculated automatically based on the values from steps 3 and 4. This will also automatically update all the CPI-U Adjusted Price fields in the cost tables."]
[null,6,"CPI-U Adjusted Prices will be subject to negotiation upon execution of a Participating Addendum."]

{"sheet":"Cost Proposal","index":1,"n_rows":98,"n_cols":28,"rows_kept":98,"merged":[[1,1,1,2],[2,1,2,2],[5,1,5,2],[8,2,8,7],[9,2,9,7],[10,2,10,7],[11,2,11,7],[13,1,13,4],[13,5,13,7],[17,1,17,3],[25,1,25,2],[28,1,29,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[28,13,28,14],[28,15,28,16],[28,17,28,18],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,29,26],[28,27,29,28],[30,1,30,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[34,1,34,4],[34,13,34,14],[34,15,34,16],[34,17,34,18],[34,19,34,20],[34,21,34,22],[34,23,34,24],[34,25,34,26],[34,27,34,28],[35,27,35,28],[38,1,39,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[38,13,38,14],[38,15,38,16],[38,17,38,18],[38,19,38,20],[38,21,38,22],[38,23,38,24],[38,25,39,26],[38,27,39,28],[40,1,40,4],[41,1,41,4],[42,1,42,4],[43,1,43,4],[44,1,44,4],[44,13,44,14],[44,15,44,16],[44,17,44,18],[44,19,44,20],[44,21,44,22],[44,23,44,24],[44,25,44,26],[44,27,44,28],[45,27,45,28],[48,1,49,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[48,11,48,12],[48,13,48,14],[48,15,48,16],[48,17,48,18],[48,19,48,20],[48,21,48,22],[48,23,48,24],[48,25,49,26],[48,27,49,28],[50,1,50,4],[51,1,51,4],[52,1,52,4],[53,1,53,4],[54,1,54,4],[54,13,54,14],[54,15,54,16],[54,17,54,18],[54,19,54,20],[54,21,54,22],[54,23,54,24],[54,25,54,26],[54,27,54,28],[55,27,55,28],[69,1,69,2],[78,1,78,2],[81,1,81,3],[82,1,82,3],[82,4,82,5],[82,6,82,7],[82,8,82,9],[82,10,82,11],[82,12,82,13],[82,14,82,15],[82,16,82,17],[82,18,82,19],[82,20,82,21],[82,22,82,23],[82,24,83,24],[83,2,83,3],[84,2,84,3],[85,2,85,3],[86,2,86,3],[87,2,87,3],[88,1,89,23],[88,24,89,24]]}
[]
[null,"State of Georgia"]
[null,"In Conjunction with NASPO ValuePoint"]
[null,"Electronic Request for Proposals (\"eRFP\")"]
[null,"eRFP (Event) Number: 41900-DCH0000136"]
[null,"Event Name: Pharmacy Benefit Services"]
[null,"Attachment Z - Pharmacy Drug Rebate Services Cost Worksheet"]
[]
[null,"SUPPLIER LEGAL ENTITY NAME:","Magellan Medicaid Administration, LLC"]
[null,"SUPPLIER REPRESENTATIVE NAME:","Billy Thomas"]
[null,"SUPPLIER REPRESENTATIVE TITLE:","SVP, Account Management"]
[null,"DATE:","2024-04-30"]
[]
[null,"TOTAL EVALUATION COST AMOUNT (Sum of Evaluation Costs Below):",{"$nulls":3},{"$f":"SUM(D26+Z35+Z45+Z55)","v":{"v":29872231.399999995,"d":"$29,872,231"}}]
[]
[null,"Table A"]
[null,"Instructions: Please enter the costs to implement your services and/or Solution."]
[null,"Design, Development, and Implementation (DDI) Cost"]
[null,null,"Initial Cost","CPI-U Adjusted Cost"]
[null,"Project Planning and Startup",{"v":103220.4,"d":"$103,220.40"},{"$f":"+C20*$C$98","v":{"v":103220.4,"d":"$103,220.40"}}]
[null,"Design, Development, and Testing",{"v":189237.4,"d":"$189,237.40"},{"v":189237.4,"d":"$189,237.40"}]
[null,"Operational Readiness and Production Cutover",{"v":172034,"d":"$172,034.00"},{"v":172034,"d":"$172,034.00"}]
[null,"Training",{"v":120423.8,"d":"$120,423.80"},{"v":120423.8,"d":"$120,423.80"}]
[null,"Acceptance, Deployment",{"v":68813.6,"d":"$68,813.60"},{"v":68813.6,"d":"$68,813.60"}]
[null,"Certification",{"v":34406.8,"d":"$34,406.80"},{"v":34406.8,"d":"$34,406.80"}]
[null,"Total DDI Costs:",null,{"$f":"SUM(D20:D25)","v":{"v":688136,"d":"$688,136.00"}}]
[]
[null,"Table B.1"]
[null,"Drug Rebate System",{"$nulls":3},"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Total for Drug Rebate System",null,"For Informational Purposes Only\nAnnual Average Drug Rebate System Cost"]
[{"$nulls":5},"Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate"]
[null,"Monthly Systems Fee"]
[null,"The monthly system fee should include the Supplier's cost to provide the drug rebate Solution, all upgrades, patches, fixes, maintenance and configuration required to provide the capability to collect Federal Rebates from the Medicaid Drug Rebate Program (MDRP) as well as bill and collect Federal Rebates from Provider administered drug claims (e.g., J-Codes) processed through the State's Care Management Organization (CMO) programs and State's Medicaid Fee-for-Service (FFS) Pharmacy Program, as discussed in the eRFP."]
[null,"Total Monthly Cost",{"$nulls":3},{"v":42409.08,"d":"$42,409"},{"$f":"F33*C98","v":{"v":42409.08,"d":"$42,409"}},{"v":42409.08,"d":"$42,409"},{"$f":"H33*C98","v":{"v":42409.08,"d":"$42,409"}},{"v":42409.08,"d":"$42,409"},{"$f":"J33*C98","v":{"v":42409.08,"d":"$42,409"}},{"v":43681.36,"d":"$43,681"},{"$f":"L33*C98","v":{"v":43681.36,"d":"$43,681"}},{"v":44991.8,"d":"$44,992"},{"$f":"N33*C98","v":{"v":44991.8,"d":"$44,992"}},{"v":46341.55,"d":"$46,342"},{"$f":"P33*C98","v":{"v":46341.55,"d":"$46,342"}},{"v":47731.8,"d":"$47,732"},{"$f":"R33*C98","v":{"v":47731.8,"d":"$47,732"}},{"v":49163.75,"d":"$49,164"},{"$f":"T33*C98","v":{"v":49163.75,"d":"$49,164"}},{"v":50638.66,"d":"$50,639"},{"$f":"V33*C98","v":{"v":50638.66,"d":"$50,639"}},{"v":52157.82,"d":"$52,158"},{"$f":"X33*C98","v":{"v":52157.82,"d":"$52,158"}}]
[{"$nulls":5},{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months"]
[null,"Total Period Cost",{"$nulls":3},{"$f":"G33*F34","v":{"v":508908.96,"d":"= $ 508,909"}},null,{"$f":"I33*H34","v":{"v":508908.96,"d":"= $ 508,909"}},null,{"$f":"K33*J34","v":{"v":508908.96,"d":"= $ 508,909"}},null,{"$f":"M33*L34","v":{"v":524176.32,"d":"= $ 524,176"}},null,{"$f":"O33*N34","v":{"v":539901.6000000001,"d":"= $ 539,902"}},null,{"$f":"Q33*P34","v":{"v":556098.6000000001,"d":"= $ 556,099"}},null,{"$f":"S33*R34","v":{"v":572781.6000000001,"d":"= $ 572,782"}},null,{"$f":"U33*T34","v":{"v":589965,"d":"= $ 589,965"}},null,{"$f":"W33*V34","v":{"v":607663.92,"d":"= $ 607,664"}},null,{"$f":"Y33*X34","v":{"v":625893.84,"d":"= $ 625,894"}},null,{"$f":"SUM(F35:X35)","v":{"v":5543207.76,"d":"= $ 5,543,208"}},null,{"$f":"Z35/10","v":{"v":554320.776,"d":"= $ 554,321"}}]
[]
[]
[null,"Table B.2"]
[null,"CMS Rebates",{"$nulls":3},"Year 1",null,"Year 2\n",null,"Year 3\n",null,"Year 4\n",null,"Year 5\n",null,"Year 6\n",null,"Year 7\n",null,"Year 8\n",null,"Year 9\n",null,"Year 10\n",null,"10-Year Total for CMS Rebate Administration",null,"For Informational Purposes Only\nAnnual Average CMS Rebate Administration Cost"]
[{"$nulls":5},"Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate"]
[null,"Monthly Administration Fee"]
[null,"The monthly administration fee should include the Supplier's cost to bill and collect Federal Rebates from the MDRP as well as bill and collect Federal Rebates from Provider administered drug claims (e.g., J-Codes) processed through the State's Care Management Organization (CMO) programs and State's Medicaid Fee-for-Service (FFS) Pharmacy Program, as discussed in the eRFP."]
[null,"Total Monthly Cost",{"$nulls":3},{"v":122550.68,"d":"$122,551"},{"$f":"F43*C98","v":{"v":122550.68,"d":"$122,551"}},{"v":122550.68,"d":"$122,551"},{"$f":"H43*C98","v":{"v":122550.68,"d":"$122,551"}},{"v":122550.68,"d":"$122,551"},{"$f":"J43*C98","v":{"v":122550.68,"d":"$122,551"}},{"v":126227.2,"d":"$126,227"},{"$f":"L43*C98","v":{"v":126227.2,"d":"$126,227"}},{"v":130014.02,"d":"$130,014"},{"$f":"N43*C98","v":{"v":130014.02,"d":"$130,014"}},{"v":133914.44,"d":"$133,914"},{"$f":"P43*C98","v":{"v":133914.44,"d":"$133,914"}},{"v":137931.87,"d":"$137,932"},{"$f":"R43*C98","v":{"v":137931.87,"d":"$137,932"}},{"v":142069.83,"d":"$142,070"},{"$f":"T43*C98","v":{"v":142069.83,"d":"$142,070"}},{"v":146331.92,"d":"$146,332"},{"$f":"V43*C98","v":{"v":146331.92,"d":"$146,332"}},{"v":150721.88,"d":"$150,722"},{"$f":"X43*C98","v":{"v":150721.88,"d":"$150,722"}}]
[{"$nulls":5},{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months"]
[null,"Total Period Cost",{"$nulls":3},{"$f":"G43*F44","v":{"v":1470608.16,"d":"= $ 1,470,608"}},null,{"$f":"I43*H44","v":{"v":1470608.16,"d":"= $ 1,470,608"}},null,{"$f":"K43*J44","v":{"v":1470608.16,"d":"= $ 1,470,608"}},null,{"$f":"M43*L44","v":{"v":1514726.4,"d":"= $ 1,514,726"}},null,{"$f":"O43*N44","v":{"v":1560168.24,"d":"= $ 1,560,168"}},null,{"$f":"Q43*P44","v":{"v":1606973.28,"d":"= $ 1,606,973"}},null,{"$f":"S43*R44","v":{"v":1655182.44,"d":"= $ 1,655,182"}},null,{"$f":"U43*T44","v":{"v":1704837.96,"d":"= $ 1,704,838"}},null,{"$f":"W43*V44","v":{"v":1755983.04,"d":"= $ 1,755,983"}},null,{"$f":"Y43*X44","v":{"v":1808662.56,"d":"= $ 1,808,663"}},null,{"$f":"SUM(F45:X45)","v":{"v":16018358.399999997,"d":"= $ 16,018,358"}},null,{"$f":"Z45/10","v":{"v":1601835.8399999996,"d":"= $ 1,601,836"}}]
[]
[]
[null,"Table B.3"]
[null,"Supplemental Rebates",{"$nulls":3},"Year 1",null,"Year 2\n",null,"Year 3\n",null,"Year 4\n",null,"Year 5\n",null,"Year 6\n",null,"Year 7\n",null,"Year 8\n",null,"Year 9\n",null,"Year 10\n",null,"10-Year Total for Supplemental Rebate Administration",null,"For Informational Purposes Only\nAnnual Average Supplemental Rebate Administration Cost"]
[{"$nulls":5},"Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate","Initial Rate","CPI-U Adjusted Rate"]
[null,"Monthly Administration Fee"]
[null,"The monthly administration fee should include the Supplier's ability to maintain an online bidding site for collection of bids, to present financial modeling for State Advisory Board meetings, to negotiate with pharmaceutical Manufacturers, to bill for contracted Supplemental Rebates, and collect Supplemental Rebates on behalf of the State's Medicaid Fee-for-Service (FFS) Pharmacy Program."]
[null,"Total Monthly Cost",{"$nulls":3},{"v":58317.22,"d":"$58,317"},{"$f":"F53*C98","v":{"v":58317.22,"d":"$58,317"}},{"v":58317.22,"d":"$58,317"},{"$f":"H53*C98","v":{"v":58317.22,"d":"$58,317"}},{"v":58317.22,"d":"$58,317"},{"$f":"J53*C98","v":{"v":58317.22,"d":"$58,317"}},{"v":60066.74,"d":"$60,067"},{"$f":"L53*C98","v":{"v":60066.74,"d":"$60,067"}},{"v":61868.74,"d":"$61,869"},{"$f":"N53*C98","v":{"v":61868.74,"d":"$61,869"}},{"v":63724.8,"d":"$63,725"},{"$f":"P53*C98","v":{"v":63724.8,"d":"$63,725"}},{"v":65636.55,"d":"$65,637"},{"$f":"R53*C98","v":{"v":65636.55,"d":"$65,637"}},{"v":67605.64,"d":"$67,606"},{"$f":"T53*C98","v":{"v":67605.64,"d":"$67,606"}},{"v":69633.81,"d":"$69,634"},{"$f":"V53*C98","v":{"v":69633.81,"d":"$69,634"}},{"v":71722.83,"d":"$71,723"},{"$f":"X53*C98","v":{"v":71722.83,"d":"$71,723"}}]
[{"$nulls":5},{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months",{"v":12,"d":"X 12"},"months"]
[null,"Total Period Cost",{"$nulls":3},{"$f":"G53*F54","v":{"v":699806.64,"d":"= $ 699,807"}},null,{"$f":"I53*H54","v":{"v":699806.64,"d":"= $ 699,807"}},null,{"$f":"K53*J54","v":{"v":699806.64,"d":"= $ 699,807"}},null,{"$f":"M53*L54","v":{"v":720800.88,"d":"= $ 720,801"}},null,{"$f":"O53*N54","v":{"v":742424.88,"d":"= $ 742,425"}},null,{"$f":"Q53*P54","v":{"v":764697.6000000001,"d":"= $ 764,698"}},null,{"$f":"S53*R54","v":{"v":787638.6000000001,"d":"= $ 787,639"}},null,{"$f":"U53*T54","v":{"v":811267.6799999999,"d":"= $ 811,268"}},null,{"$f":"W53*V54","v":{"v":835605.72,"d":"= $ 835,606"}},null,{"$f":"Y53*X54","v":{"v":860673.96,"d":"= $ 860,674"}},null,{"$f":"SUM(F55:X55)","v":{"v":7622529.239999998,"d":"= $ 7,622,529"}},null,{"$f":"Z55/10","v":{"v":762252.9239999999,"d":"= $ 762,253"}}]
[]
[]
[null,"Table C"]
[null,"Note: The requested information below will be used for information purposes only."]
[null,"Instructions:  Please enter your average annual operational costs in the unprotected cells below. Provide a breakdown of \"Other\" costs, if included. "]
[null,"Annual Operation & Maintenance","CMS Rebates","CPI-U Adjusted Cost","Supplemental Rebates","CPI-U Adjusted Cost"]
[null,"Staffing",{"v":1540268.45,"d":"$1,540,268.45"},{"$f":"+C62*$C$98","v":{"v":1540268.45,"d":"$1,540,268.45"}},687618.5,{"$f":"+E62*$C$98","v":{"v":687618.5,"d":"$687,618.50"}}]
[null,"Training",{"v":23362.6,"d":"$23,362.60"},{"$f":"+C63*$C$98","v":{"v":23362.6,"d":"$23,362.60"}},11117.37,{"v":11117.37,"d":"$11,117.37"}]
[null,"Rebate Processing and Systems",{"v":375591.19,"d":"$375,591.19"},{"$f":"+C64*$C$98","v":{"v":375591.19,"d":"$375,591.19"}},178729.6,{"v":178729.6,"d":"$178,729.60"}]
[null,"Rebate Negotiation","N/A","N/A",45336.84,{"v":45336.84,"d":"$45,336.84"}]
[null,"Postage and Mailing",{"v":3112.71,"d":"$3,112.71"},{"$f":"+C66*$C$98","v":{"v":3112.71,"d":"$3,112.71"}},1481.22,{"v":1481.22,"d":"$1,481.22"}]
[null,"Printing",{"v":734.8,"d":"$734.80"},{"$f":"+C67*$C$98","v":{"v":734.8,"d":"$734.80"}},349.67,{"v":349.67,"d":"$349.67"}]
[null,"Reports",{"v":18892.62,"d":"$18,892.62"},{"$f":"+C68*$C$98","v":{"v":18892.62,"d":"$18,892.62"}},8990.28,{"v":8990.28,"d":"$8,990.28"}]
[null,"Other**",{"v":15464.68,"d":"$15,464.68"},{"$f":"+C69*$C$98","v":{"v":15464.68,"d":"$15,464.68"}},7359.05,{"v":7359.05,"d":"$7,359.05"}]
[null,"Total Operational Cost:",null,{"$f":"SUM(D62:D69)","v":{"v":1977427.05,"d":"$1,977,427.05"}},null,{"$f":"SUM(F62:F69)","v":{"v":940982.53,"d":"$940,982.53"}}]
[]
[null,"**Other Costs Breakdown"]
[null,"Surety Bond",{"v":15464.68,"d":"$15,464.68"},{"$f":"+C73*$C$98","v":{"v":15464.68,"d":"$15,464.68"}},7359.05,{"$f":"+E73*$C$98","v":{"v":7359.05,"d":"$7,359.05"}}]
[{"$nulls":3},0,null,0]
[{"$nulls":3},0,null,0]
[{"$nulls":3},0,null,0]
[{"$nulls":3},0,null,0]
[{"$nulls":3},0,null,0]
[null,"Total Other Costs:",null,{"$f":"SUM(D72:D78)","v":{"v":15464.68,"d":"$15,464.68"}},null,{"$f":"SUM(F72:F78)","v":{"v":7359.05,"d":"$7,359.05"}}]
[]
[null,"Table D "]
[null,"Instructions: Complete the section below by entering the Hourly Rate in the yellow boxes for each identified Role. As may be requested by the State on a case by case basis and agreed upon by the Contractor, the Contractor will provide ad hoc services related to potential tasks as described below.\n\nNote: These charges will only be billed for project-related services not specified in the eRFP and requested by the State for such services in writing. The total cost for all State requested and approved projects shall not exceed the amount indicated by the State in its Participating Addendum. The proposed costs will not be evaluated as part of the total contract value."]
[null,"Ad Hoc Professional Services",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Year 6",null,"Year 7",null,"Year 8",null,"Year 9",null,"Year 10",null,"10-Year Average of Hourly Rates"]
[null,"Role","Potential Responsibilities",null,"Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate","Initial Hourly Rate","CPI-U Adjusted Rate"]
[null,"Business Analyst","Evaluates business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing Solutions.",null,{"v":89,"d":"$89.00"},{"$f":"MAX(ROUND(E85*$C$98,2),0)","v":{"v":89,"d":"$89.00"}},{"v":91.67,"d":"$91.67"},{"$f":"MAX(ROUND(G85*$C$98,2),0)","v":{"v":91.67,"d":"$91.67"}},{"v":94.42,"d":"$94.42"},{"$f":"MAX(ROUND(I85*$C$98,2),0)","v":{"v":94.42,"d":"$94.42"}},{"v":97.25,"d":"$97.25"},{"$f":"MAX(ROUND(K85*$C$98,2),0)","v":{"v":97.25,"d":"$97.25"}},{"v":100.17,"d":"$100.17"},{"$f":"MAX(ROUND(M85*$C$98,2),0)","v":{"v":100.17,"d":"$100.17"}},{"v":103.18,"d":"$103.18"},{"$f":"MAX(ROUND(O85*$C$98,2),0)","v":{"v":103.18,"d":"$103.18"}},{"v":106.28,"d":"$106.28"},{"$f":"MAX(ROUND(Q85*$C$98,2),0)","v":{"v":106.28,"d":"$106.28"}},{"v":109.47,"d":"$109.47"},{"$f":"MAX(ROUND(S85*$C$98,2),0)","v":{"v":109.47,"d":"$109.47"}},{"v":112.75,"d":"$112.75"},{"$f":"MAX(ROUND(U85*$C$98,2),0)","v":{"v":112.75,"d":"$112.75"}},{"v":116.13,"d":"$116.13"},{"$f":"MAX(ROUND(W85*$C$98,2),0)","v":{"v":116.13,"d":"$116.13"}},{"$f":"(F85+H85+J85+L85+N85+P85+R85+T85+V85+X85)/10","v":{"v":102.03200000000001,"d":"$102.03"}}]
[null,"Senior Developer","Responsible for designing, testing, and implementing new and updated software programs.",null,{"v":151.44,"d":"$151.44"},{"$f":"MAX(ROUND(E86*$C$98,2),0)","v":{"v":151.44,"d":"$151.44"}},{"v":155.98,"d":"$155.98"},{"$f":"MAX(ROUND(G86*$C$98,2),0)","v":{"v":155.98,"d":"$155.98"}},{"v":160.66,"d":"$160.66"},{"$f":"MAX(ROUND(I86*$C$98,2),0)","v":{"v":160.66,"d":"$160.66"}},{"v":165.48,"d":"$165.48"},{"$f":"MAX(ROUND(K86*$C$98,2),0)","v":{"v":165.48,"d":"$165.48"}},{"v":170.44,"d":"$170.44"},{"$f":"MAX(ROUND(M86*$C$98,2),0)","v":{"v":170.44,"d":"$170.44"}},{"v":175.55,"d":"$175.55"},{"$f":"MAX(ROUND(O86*$C$98,2),0)","v":{"v":175.55,"d":"$175.55"}},{"v":180.82,"d":"$180.82"},{"$f":"MAX(ROUND(Q86*$C$98,2),0)","v":{"v":180.82,"d":"$180.82"}},{"v":186.24,"d":"$186.24"},{"$f":"MAX(ROUND(S86*$C$98,2),0)","v":{"v":186.24,"d":"$186.24"}},{"v":191.83,"d":"$191.83"},{"$f":"MAX(ROUND(U86*$C$98,2),0)","v":{"v":191.83,"d":"$191.83"}},{"v":197.58,"d":"$197.58"},{"$f":"MAX(ROUND(W86*$C$98,2),0)","v":{"v":197.58,"d":"$197.58"}},{"$f":"(F86+H86+J86+L86+N86+P86+R86+T86+V86+X86)/10","v":{"v":173.60199999999998,"d":"$173.60"}}]
[null,"Developer","Responsible for developing, coding, installing, and maintaining software systems.",null,{"v":121.15,"d":"$121.15"},{"$f":"MAX(ROUND(E87*$C$98,2),0)","v":{"v":121.15,"d":"$121.15"}},{"v":124.78,"d":"$124.78"},{"$f":"MAX(ROUND(G87*$C$98,2),0)","v":{"v":124.78,"d":"$124.78"}},{"v":128.52,"d":"$128.52"},{"$f":"MAX(ROUND(I87*$C$98,2),0)","v":{"v":128.52,"d":"$128.52"}},{"v":132.38,"d":"$132.38"},{"$f":"MAX(ROUND(K87*$C$98,2),0)","v":{"v":132.38,"d":"$132.38"}},{"v":136.35,"d":"$136.35"},{"$f":"MAX(ROUND(M87*$C$98,2),0)","v":{"v":136.35,"d":"$136.35"}},{"v":140.44,"d":"$140.44"},{"$f":"MAX(ROUND(O87*$C$98,2),0)","v":{"v":140.44,"d":"$140.44"}},{"v":144.65,"d":"$144.65"},{"$f":"MAX(ROUND(Q87*$C$98,2),0)","v":{"v":144.65,"d":"$144.65"}},{"v":148.99,"d":"$148.99"},{"$f":"MAX(ROUND(S87*$C$98,2),0)","v":{"v":148.99,"d":"$148.99"}},{"v":153.46,"d":"$153.46"},{"$f":"MAX(ROUND(U87*$C$98,2),0)","v":{"v":153.46,"d":"$153.46"}},{"v":158.06,"d":"$158.06"},{"$f":"MAX(ROUND(W87*$C$98,2),0)","v":{"v":158.06,"d":"$158.06"}},{"v":138.87800000000001,"d":"$138.88"}]
[null,"Quality assurance/Test","Works with the development team to debug code, correct errors, and troubleshoot any issues with software code.",null,{"v":97.9,"d":"$97.90"},{"$f":"MAX(ROUND(E88*$C$98,2),0)","v":{"v":97.9,"d":"$97.90"}},{"v":100.84,"d":"$100.84"},{"$f":"MAX(ROUND(G88*$C$98,2),0)","v":{"v":100.84,"d":"$100.84"}},{"v":103.87,"d":"$103.87"},{"$f":"MAX(ROUND(I88*$C$98,2),0)","v":{"v":103.87,"d":"$103.87"}},{"v":106.99,"d":"$106.99"},{"$f":"MAX(ROUND(K88*$C$98,2),0)","v":{"v":106.99,"d":"$106.99"}},{"v":110.2,"d":"$110.20"},{"$f":"MAX(ROUND(M88*$C$98,2),0)","v":{"v":110.2,"d":"$110.20"}},{"v":113.51,"d":"$113.51"},{"$f":"MAX(ROUND(O88*$C$98,2),0)","v":{"v":113.51,"d":"$113.51"}},{"v":116.92,"d":"$116.92"},{"$f":"MAX(ROUND(Q88*$C$98,2),0)","v":{"v":116.92,"d":"$116.92"}},{"v":120.43,"d":"$120.43"},{"$f":"MAX(ROUND(S88*$C$98,2),0)","v":{"v":120.43,"d":"$120.43"}},{"v":124.04,"d":"$124.04"},{"$f":"MAX(ROUND(U88*$C$98,2),0)","v":{"v":124.04,"d":"$124.04"}},{"v":127.76,"d":"$127.76"},{"$f":"MAX(ROUND(W88*$C$98,2),0)","v":{"v":127.76,"d":"$127.76"}},{"v":112.24600000000001,"d":"$112.25"}]
[null,"Total Ad Hoc Professional Services Cost (Sum of 10-Year Average of Hourly Rates for all Identified Roles)",{"$nulls":22},{"$f":"SUM(Y85:Y88)","v":{"v":526.758,"d":"$526.76"}}]
[]
[]
[null,"Table E"]
[null,"Consumer Price Index Urban (CPI-U) Adjustment:"]
[null,"A. CPI-U for Master Agreement Date MM/DD/20YY:",{"v":0,"d":"0.000000"}]
[null,"B. CPI-U for Participating Addendum Date:",{"v":0,"d":"0.000000"}]
[null,"C. Index Point Change equals B minus A:",{"$f":"C95-C94","v":{"v":0,"d":"0.000000"}}]
[null,"D. Equals C divided by A:",{"$f":"IFERROR(C96/C94,0)","v":{"v":0,"d":"0.000000"}}]
[null,"E. CPI-U Inflation Percentage equals B plus 1.00:",{"$f":"C97+1","v":{"v":1,"d":"1.000000"}}]

{"sheet":"Scoring Formula","index":2,"n_rows":15,"n_cols":2,"rows_kept":15,"merged":[[2,1,2,2],[3,1,3,2],[6,1,6,2],[9,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,15,3]]}
[]
[]
[null,"State of Georgia"]
[null,"In Conjunction with NASPO ValuePoint"]
[null,"Electronic Request for Proposals (\"eRFP\")"]
[null,"eRFP (Event) Number: 41900-DCH0000136"]
[null,"Event Name: Pharmacy Benefit Services"]
[null,"Attachment Z - Pharmacy Drug Rebate Services Cost Worksheet"]
[]
[null,"Cost Scoring Formula"]
[]
[]
[null,"\nThe Supplier deemed to have the most competitive cost response overall, as determined by the Lead State, will receive the maximum score for the cost criteria. As a general rule, other Suppliers’ cost responses will receive a percentage of the maximum score based on the percentage differential between the most competitive cost proposal and the specific proposal in question. This cost scoring can be accomplished using the following formula:"]
[null,"\nL/R x P = Z\n\nL = Price of the Supplier's response with the lowest cost.\nR = Total cost of the Proposal being ranked.\nP = Total points available for cost scoring.\nZ = Assigned Points."]
[null,"EXAMPLE  - The Lead State receives responses from two Suppliers on an RFP.  The RFP assigned 700 possible points for technical scores and 300 possible points for cost scores. Supplier A's cost proposal is $50,000. Supplier B's cost proposal is $55,000. As Supplier A offered the lowest cost, Supplier A receives 300 points. The issuing officer can calculate the number of cost points to assign to Supplier B's cost score by using the formula noted above. As shown below, Supplier B's total cost score is 272.7 points.\n\nL/R x P = Z\n($50,000/$55,000) x 300 = Z\n.909 x 300 = Z\n272.7 = Z"]